Job Reporting

The Deacom Job Reporting pre-filter contains a number of different reports which each contain different variables and information that can be used for Job analysis. This page outlines the different reports and pre-filters that are available. For a list of the calculated variables on the Job Cost Summary, Job Cost Detail, and Production Costs reports and additional fields available to several of the reports in this section, refer to the Calculated Variables and Available Fields on Production Reports page. Some reports also allow users access to the "Custom Adds" button, which opens the Custom BOM form and is used to modify the selected item's Bill Of Materials for the selected Job only.

Understanding inventory and GL effects when issuing inventory

Issuing is the reservation of inventory Lots to a specific production Job. Deacom allows users to specifically select Lots or allows the system to automatically select the appropriate Lots based on the FIFO or LIFO concepts. The issuing of materials to a production Job occurs via the following methods:

  • During job creation, after the job has been saved, via the “Issue” button on the job header.
  • After the job has been saved via the Inventory > Issue/Reserve Inventory transaction.
  • After the job has been saved, via the “Issue” button on several of the report forms within Production > Job Reporting.
  • Within the Deacom WMS application on a scanner via the “Issue Job” transaction.
  • On the Jobs and Job Inventory calendars via the “Issue” button on the Daily Job Calendar form.

Additional information on the issuing process is available via the Issuing and Reserving Material Best Practice page.

The General Ledger impact when material is issued, in all costing methods, is a debit to the WIP Materials account and a credit to the Inventory account, both specified on the Item Master Accounts tab. Sample account postings related to issuing are available via Deacom Basics > Sample Accounting Postings.

From an inventory management perspective, the impact of issuing is that issued materials are placed in the WIP inventory bucket. WIP inventory is defined as known good inventory that has been issued to a specific production job, awaiting relief of issued inventory (usage). Items/lots in WIP can be de-issued and issued to a different production Job if necessary. Inventory should not remain in WIP for extended periods. The Inventory "Aged" report is useful for reviewing inventory quantities in WIP. In situations where the amount of inventory issued is greater then what was used when finishing, users may wish to de-issue the excess before closing the job. This can be accomplished via the Inventory > De-Issue/Un-Reserve function. It is important to note that excess inventory located in WIP must be de-issued before the Job is closed. If excess inventory is not de-issued, and the job is closed, a material expense variance will be reflected in the general ledger.

Performing QC testing before or during production

Significant changes were made to the QC data structure in version 14.3. Previously, the QC structure linked results directly to the job or purchase order, allowing for users to keep the "QC Values" button directly on the job. Starting with the 14.3 build, QC results are linked to lots. This provides a much more robust QC solution and has allowed the addition of many new QC features. For example, users can now do separate QC testing for each lot that is produced on a job. Because the QC results are tied to a lot, users must now go through the “Inventory” button on a job to view the lot information.

The entry of QC results before or during the production process is now handled via the "QC Values" button which is available when modifying a job, via the buttons menu in various Job reports, or on the Close/Relieve Job form, which is displayed by clicking the "Close/Relieve" button in various Job reports. The setting that determines whether QC testing will be performed during or after production is the “Do QC After Production” flag on the Quality Control Group. If this flag is not checked on the QC Group and the QC Group is attached to an item's BOM revision, then QC testing may be performed on Jobs containing that revision via the Close/Relieve form.

The Quality Control Results form provides details on all the fields and options available and is opened via the "QC Values" button as indicated above. See the Entering Production and Stability QC Test Results Best Practices page for information on how perform and and approve QC results.

Calculated Fields

Deacom reports contain calculated fields that provide users with additional information including sums or totals. The list below contains some of the most commonly used calculated fields in the production area:

Report

Field

Calculation/Definition

Notes

Job Cost Summary

acthours 

j3_modhour + j3_modot

 

allcosts

 matcost + labcost + machcost + burcost + purcost

j3_* fields are based on Job Time Entries (dtjob3 table)

burcost 

j3_calctime x (op_burden + wo_burden)

j3_* fields are based on Job Time Entries (dtjob3 table)

burcostop 

j3_calctime x op_burden

 

burcostworker 

j3_calctime x wo_burden

 

finbur 

j4_finbur x j4_quant

j4_fix* fields are set by the corresponding pr_fix* fields at the time of job finish

finlab

j4_finlab x j4_quant

j4_fix* fields are set by the corresponding pr_fix* fields at the time of job finish

finlabcost

 j4_fixlab x j4_quant

j4_fix* fields are set by the corresponding pr_fix* fields at the time of job finish

finmatcost

j4_fixmat x j4_quant

j4_fix* fields are set by the corresponding pr_fix* fields at the time of job finish

finstantot

j4_stantot x j4_quant

j4_fix* fields are set by the corresponding pr_fix* fields at the time of job finish

finunitcost

 j4_unitcos x j4_quant

j4_fix* fields are set by the corresponding pr_fix* fields at the time of job finish

j4_quant

 Quantity finished

 

labcost

j3_modhour x j3_rate x j3_ratefac

j3_* fields are based on Job Time Entries (dtjob3 table)

machcost

 (j3_modhour + j3_modot) x j3_cenrate

j3_* fields are based on Job Time Entries (dtjob3 table)

matcost

issued/relieved quantity x issued/relieved lot cost (fi_cost)

j3_* fields are based on Job Time Entries (dtjob3 table)

prfact

stock to pricing conversion

 

purcost

issued/relieved quantity x issued/relieved lot cost (fi_cost)

j3_* fields are based on Job Time Entries (dtjob3 table)

stanbur

 pr_fixbur x prfact x j4_quant

 

stanlab

pr_fixlab x prfact x j4_quant

 

stanmat

pr_fixmat x prfact x (j4_quant - re-work qty issued)

 

stantot

stanmat + stanlabl + stanbur

 

variance

allcosts - stantot

 

System Navigation

  • Production > Job Reporting

Job Reporting pre-filter

Field

Description

Report Type

Pick list used to dictate the type of report that will generate. Deacom Version 16.02 includes the ability to create unlimited user versions of any job report for users with permission and also expanded the security that determines which reports each user will see in this field. See the Configuring Grid Layouts and Automated Reports and Grid Layout Security pages for information. Options are:

  • Consumed Inventory -  The report will display all finishes for jobs that meet the filter criteria, as well as the lots relieved into those finishes. Materials expensed at job close will not be included in this report. The relief and finish transactions will be in chronological order, but grouped by job. Un-finishes / Un-relieve will also show.
    • Added in version 17.04.003.
  • Expensed Material - Displays inventory that is relieved at the end of the Job, but does not get relieved into a specific Lot, which typically occurs when the "Relieve All Issued Materials" flag is checked when closing a Job where nothing was produced/finished on the Job.
    • Example: If a Subassembly or blend is relieved but not finished, the amount of Raw Material in that blend is not accounted for in various existing Inventory reports, such as "Lot Tracking Implosion".
    • Note: Users have the option to un-relieve 'expensed materials' as a job is re-opening. A prompt will display asking the user "Would you like to un-relieve the expensed lots from this job?"
  • Job Cost Detail - Detailed report which displays unit, material, labor, and burden costs for each Part on the selected Jobs.
    • Beginning in version 16.03.048, and when using the "Labor Cost Expression" field to calculate labor, the labor cost will be stored in the "Actual Labor Cost" (j4_labcost) field in the "Job Completions" (dtjob4) table. Actual labor may be viewed on the Job Cost Detail report.
  • Job Cost Summary - Summary report which displays the total unit, material, labor and burden costs for each job based on the selection criteria used in the pre-filter.
    • When adding Routing sequences on a Job, the "Planned Hours" field is available for editing. When modifying an existing Job Routing, it is read only. The purpose of this field is to indicate how long users estimate the task would take to complete. This allows the system to compare the actual hours/dollars to the planned hours/dollars. This report uses this new field to calculate Standard Labor.
    • On this report, the following calculations are used:
      • Std. Total is the sum of all standard variables listed (Std. Materials, Std Labor, Std Burden).
      • Act. Total is the sum of all actual variables listed (Act. Materials, Work Center, Act. Labor, Purchases).
      • Variance is the difference between the totals. This value is typically the most important and used to indicate when costs need to be updated. A negative value is desired.
      • Std. Materials is the total finish quantity multiplied by the "Acct. Materials" value from the Item Master Costs tab of the Finished Good.
      • Act. Materials is the sum of all costs of Lots at the time they are relieved on the Job. This value can be obtained by using the "Inventory" button on individual Jobs.
      • Act. Labor is the sum of payroll postings tied to the Job.
      • Work Center cost is based on payroll.
    • Additional information on some of the calculated fields used on this report is available via the Calculated Fields section on this page.
  • Job Detail - Detailed report showing Part numbers, Part descriptions, Part unit weights, original quantities, completed quantities, incremental job quantities, and remaining quantities for all production order lines.
  • Job Material Cost Detail - Detailed report which displays the planned quantity, actual quantity, planned material cost, and actual material costs for each Part on the selected Jobs.
    • Combines multiple Lots of the same item together onto the same line, which allows the quantity and cost variances to be correct.
    • Will sum costs when items are contained on BOMs more than once.
    • Will sum costs in situations where more than one Lot of an item is issued.
    • Items that are not on a BOM, but were issued and relieved as a result of the production process, are included in this report.
    • The FinishedQty and FinishedCost variables are available to this report and are useful for cost analysis. They represent the amount of material that was used to produce the Bill of Materials item that is displayed in the report.
  • Job Summary - Summary report showing the remaining quantity, completed quantity, and the job creation, planned start, planned finish, due, and completion dates.
    • Starting in version 16.01.009, the "View Docs" button is available to this report, allowing users to add files or pictures directly to jobs without requiring users to drill into the selected job.
    • When printing any of the Batch Ticket 1-3 reports from the Job Summary report, the printed date from the job header will be populated.
  • Production Costs - Detail report showing shift efficiency. When the report is run, a mover form appears with 6 options on the left: Job, Operation, Shift, Shop Area, Work Center, Work Crew. When these options are moved to the right they will be in the order in which they are moved. Once "Continue" is clicked, the report grid appears, the options selected will be the left-most columns, in order, with the rest of the default columns from the grid layout following them.
    • The base data for the report is the dtjob4, dtjob, and dtjob3 table information grouped together where jo_id matches j3_joid and j4_joid.
    • If Shift is one of the grouping criteria, the shift in dtjob3 will match the shift in dtjob4 in the join.
    • If Crew is one of the grouping criteria, the shift in dtjob3 will match the crew in dtjob4 in the join. The criteria is then to group by whatever is selected.
    • Group By: Job: jo_jobnum, Operation: j3_opid, Work Center: j3_ceid, Shift: j4_sfid, Work Crew: j4_crid.
  • Production Detail - Detail report showing completion dates, original quantity, and finished quantity for each Part on the selected Jobs.
    • This report contains a "Time" field to represent the time portion of fi_recdate of the finish job dtfifo record. A blank Time indicates the Job is for a non-stock part which has no job finish record.
    • All Job header (dtjob) fields are available to this report.
    • Users have the option to Un-Finish a product on this report via the Un-Finish button. See the Un-Finishing Inventory page for more information.
  • Production Summary - Summary level report showing finish quantities by Part and by date. Results are grouped by job line number and completion date.
    • Users have the option to Un-Finish a product on this report via the Un-Finish button. See the Un-Finishing Inventory page for more information.
      • Note: When using the "Un-Finish" button, the default quantity will be the finished quantity column of the highlighted grid row(s).
  • QC Detail - Displays all the lots that contain QC results along with the Quality Control Test, test description, Minimum, Maximum, Target, and actual values entered for each Part on the selected Jobs. The fields in the Quality Control Group (dmqc) table are available to this report and can be used to add the QC Group Name and other relevant information. QC Test user fields are available to this report. Beginning in version 16.04.019, this report will also display QC results for non stock parts where the QC Group is marked as "Do QC After Production."
  • QC Summary - Summary report showing the number of QC passes performed and pass/fail results for each pass for each Part on the selected Jobs, including maintenance Jobs. QC Test user fields are available to this report. Beginning in version 16.04.019, this report will also display QC results for non stock parts where the QC Group is marked as "Do QC After Production."
  • Shop Schedule - Displays the Operation, Work Center, and Routing sequence for each Part on the selected Jobs, the original quantity and finished quantity for each part, as well as the total weight of items issued to each Job. This report also shows payroll entries without a matching Job Routing, which have blank default columns of "Part" and "Job For" and a sequence of 0.
  • Staged Inventory - Shows staged inventory quantities by part for all job lines displayed on the report. Inventory may be final staged from this report via the "Final Staging Job" button located at the top of the report. This allows users to Final Stage the same part on multiple job lines, on multiple jobs. This option, sometimes referred to as gang weigh staging, is useful in situations where users need to weigh up parts at the same time. See the Staging Material Best Practice page for information on how to final stage inventory.
  • WIP Detail - Detailed report showing the finished quantity together with the actual material, labor, and burden costs versus the standard material, labor, and burden costs for each Part on the selected Jobs.
  • WIP Summary - Summary report showing the finished quantity together with the actual material, labor, and burden costs versus the standard material, labor, and burden costs for each Job.
  • Work Center Capacity - Capacity report based on Sales Forecasts used to anticipate if companies can fit a new projected order into the forecast.
    • Useful for manufacturers who are looking at their production capacity when they forecast future sales.
    • Can help answer the question: "Can we fit all these jobs into our current production operations or do we need to add additional capacity to satisfy our forecast?"
    • The total time available within the Work Center is calculated using Availability, Availability Exceptions, and MRO blackouts. The “bottom level” Work Centers are used to drive the availability. So if there is a Work Center with no children, just that Work Center is used to drive availability.
    • Example: If there is a Work Center called "Bottling Lines" and it has 10 children, "Bottling Line 1" through "Bottling Line 10", the children are used to drive the availability for the purpose of forecasting across all bottling lines at once. Bottling Lines shows on the report, with the availability as the sum of all of the children. If the children also have children, those grand-children (so to speak) drive the availability.
    • The total consumed time is calculated based on the BOM requirements for the Parts in the selected forecasts. The Routings from the default non-facility-specific revisions for the items on the forecast and the Routings of any Subassemblies of those forecasted items are used to drive usage per bucket. This calculation differs based on whether or not the Routing is a batch routing.
      • Non-Batch: These Routings are per-unit, so the calculation is as follows: ForecastedQuantity * RoutingStepHours / RoutingStepUnits.
      • Batch: These Routings are per batch, so the default Job quantity (Job Maximum) from the Item Master MRP tab is used as follows: RoutingStepHours * (ForecastedQuantity / DefaultJobQuantity). If the default job quantity is less than or equal to zero, the batch size is treated as 1. If the "Use MRP Settings" flag is checked in Routings, that Job Maximum will be used instead.
  • Work Center Loading Detail - Displays the Work Center Operation, quantity, run hours, and start and stop times for each Part on the selected Jobs. All Item Master (dmprod) fields are available to this report.
  • Work Center Loading Summary - Summary report displaying the daily available hours, total hours used, and total days worked for each Work Center.

View

Pick list used to determine what Jobs are included in the report. Options are: All, Canceled Jobs, Closed Jobs, Jobs In Request, Jobs On Hold, Open and Closed Jobs, Open Jobs.

Job Type

Pick list used to determine the type of Jobs displayed in the report. Options are: All, Maintenance, Production.

Cost Type

Pick list used to determine the cost type that will be displayed in the report. Options are: All, Labor, Machine , Materials, Purchases.

Date Based On

Used in conjunction with the Start and End Dates to dictate the date used to filter for Jobs. Options are: Closed, Created, Due, Job Date 1-5, Planned Finish, Planned Start, Started.

Start Date/End Date

Used in conjunction with the "Date Based On" filter to display Jobs.

  • Only applies to header date fields.

Job Number

Search field used to filter for a specific Job.

Job Category

Search field used to filter for only Jobs that are assigned to the selected Job Category.

Facility

Search field used to filter for only Jobs that have the selected Facility assigned.

Facility Group

Search field used to filter for only Jobs that have Facilities belonging to the selected Facility Group.

  • Users may be restricted to viewing only Jobs belonging to the Facilities in a specific Facility Group. Additional information is available via Managing Users and User Security.

Part Number

Search field used to filter for only Jobs that contain the selected Part.

Parts Starts With

Filters for only Jobs for Parts that begin with the input character string.

Sales Order

Search field used to filter for only Jobs linked to the selected Sales Order.

Progress Billing

Search field used to filter for only Jobs connected to the selected Progress Billing order.

Project

Search field used to filter for only Jobs related to the selected Project.

Item Planner

Search field used to filter for only Jobs that contain Parts assigned to the selected Item Planner.

Item Type

Pick list used to filter for only Jobs that contain Parts assigned to the selected Item Type.

  • Definitions for each of the options are available via the "Item Type" field description in Item Master > General 1 tab.

Category

Search field used to filter for only Jobs that contain Parts within the selected Category.

Sub-Category

Search field used to filter for only Jobs that contain Parts within the selected Sub-Category.

Item Search 1-5

Search field used to filter for only Jobs that contain the selected Item Search 1-5 values.

  • Captions for these fields are maintained via System > Maintenance > Captions and options are maintained in the Inventory Maintenance section.

Forecast

Search field used to filter for only Jobs with the selected Forecast.

Shop Area

Search field used to filter for only Jobs with the selected Shop Area.

Work Center Type

Search field used to filter for only Jobs whose Routings contain Work Centers belonging to the selected Work Center Type.

Work Center

Search field used to filter for only Jobs with the selected Work Center.

Operation

Search field used to filter for only Jobs with the selected Operation.

Worker

Search field used to filter for only Jobs worked on by the selected Worker.

Work Crew

Search field used to filter for only Jobs with the selected Crew assigned.

Work Flow Type

Search field used to filter for only Jobs with the selected Work Flow assigned.

Sequence

Search filed used to filter for only Jobs with the selected Work Flow Sequence.

Assigned User

Search field used to select a User to show Jobs with Work Flow Sequences yet to be completed and assigned to the selected User.

  • Completed Work Flow Sequences assigned to the selected User will not be included.

Operations

Pick list used to filter based on the status of the "Operation Complete" checkbox on Job Routing Sequences. Operations are All, Complete, and Incomplete.

  • Only available when selecting a Report Type of Shop Schedule.
  • If Incomplete is selected, the Shop Schedule will only return records where the "Operation Complete" ( j2_done field) on Job Routing Sequences is unchecked.
  • If Complete is selected, the Shop Schedule will only return records where the "Operation Complete" ( j2_done field) on Job Routing Sequences is checked.

Job Reporting report buttons

Report results are generated by clicking "View" on the Job Reporting pre-filter. Not all buttons detailed below are available for all reports.

Button

Description

New

Allows authorized users to create a Job Entry via the Job Lines form.

Modify

Allows authorized users to modify a Job via the Job Lines form. 

View Docs

Starting in version 16.01.009 this button allows users to attach files or pictures directly to the selected job without having to drill into the job.

  • Only available when running a Report Type of Job Summary.

Purchases

Generates a Purchasing "Order Detail" report for the selected Job

View Detail

Opens the selected Job in view mode. See the job view mode section on this page for more detailed information.

Print

Opens the Copies to Print form, which is used to print various Job reports.

  • The "Pick List Facility" selection in Production Options controls how Job requirements will be gathered when printing Job Pick lists.

Material Costs

Generates a "Job Material Costs Detail" report for the selected Job.

Final Staging Job

Opens the Final Staging form, which is the second step in the two step staging process, and results in the material that was pre-staged being issued to the production Job.

  • Allows users to final stage the same Part on multiple Job lines, on multiple Jobs.
  • Sometimes referred to as gang weigh staging, this option is useful in situations where users need to weigh up parts at the same time.

Un-Finish

Opens the Un-Finish form, which is used to select a date and, when "Apply" is clicked, un-finish the previously finished material on the selected Job.

  • Only material that is still in Deacom may be un-finished. In other words, material shipped on a Sales Order may not be un-finished.

Issue

Opens the Issue/Reserve Inventory form, which is used to issue Lots to the selected Job.

  • No Part numbers will be displayed on the form once the full quantity of the Job has been finished.

De-Issue

Opens the De-Issue/Un-Reserve Inventory form, which is used to de-issue Lots from the selected Job.

  • This button will be grayed out for certain reports such as Production Detail and Job Cost Summary, since de-issuing would not be initiated from these reports.

View Postings

Generates an Accounting Reporting "General Ledger Detail" report for the selected Job.

Work Center

Generates a "Work Center Loading Detail" report for the selected Job.

Close/Relieve

Opens the Close/Relieve Job form, which can be used to enter QC results when the Quality Control Group is flagged for pre-production, finish material, and close the Job.

Edit Data

Opens the Input Job Routing form, which is used to edit Job Routing information.

  • Users may change the start time of the Routing for this line, provided a start date has been specified.
  • When changing start times for the first sequence in a Routing, the system will display a prompt asking if you wish to reschedule the other Routing sequences for the Job.
  • Users may change the associated Work Center for Shop Schedule reports. Only applicable Work Centers will be displayed in the search box.
  • When inputting multiple sequences at a time, the Next/Previous buttons allow the user to quickly move through and save multiple records.

Print Line

Opens the Copies to Print form for only the line selected.

QC Values

Opens the Quality Control Results form, which is used to enter, review, approve, and fail QC results.

  • Additional information on entering QC results for jobs is available via the Entering Production and Stability QC Test Results page.

User Fields

Displays a list of active Job User Fields, which may be used to store additional information regarding the Job or the Job close process.

  • Only available when report type is "Job Summary" or "Job Detail".

Labor Costs

Generates a Payroll Reporting "Job Payroll Detail" report for the selected Job.

Production Costs

Opens the Selected Reports mover form, which is used to generate a "Production Costs" report and displays shift efficiency information for the selected Job.

Close/Relieve Job form

Opened via the "Close/Relieve" button on various Production reports, which displays all lines that are available to be finished.

  • If the Production Options flag "Show Lines With Zero Left to Finish in Input Production" is checked, lines with zero quantity left to finish will appear in the form as well.
  • In situations where the amount of inventory issued is greater then what was used when finishing, users may wish to de-issue the excess before closing the job, otherwise it will be relieved.

Button/Field/Flag

Description

Modify

Opens the Close/Relieve Job form, which is used to enter finish quantities, leftover quantities, attributes, Lot details, and Location information for the selected item/line on the Job.

Save

Commits any changes made in the form and either closes the job, finishes the quantities entered, or both depending on the selections made.

Custom Adds

Opens the Custom BOM form, which is used to modify the selected item's Bill of Materials for the selected Job only.

  • Unavailable when using Job Type of "Planning".

QC Values

Opens the Quality Control Results form, which is used to enter, review, approve, and fail QC results. 

User Fields

Displays a list of active Job User Fields, which may be used to store additional information regarding the Job or the Job close process.

View Required

Displays the list of the quantities of the materials or components required to complete the Job based on its BOM.

View Issued

Generates an Inventory "Lot Summary - User Lot" report, which displays a list of any items and quantities that have been issued to the Job.

View Staged

If clicked, generates an Inventory Reporting Lot Summary report, which lists the information for inventory previously staged to the selected Job.

  • Note that inventory lots summed as a result of the "Summarize Lots When Viewing Issued Materials" system option will not apply to the "View Staged" button.
  • The Inventory Lot Summary report grid (invlot) contains a new variable/column called "Iteration" to display the staging iteration (st_stagcnt) for the stagged lot.

Catch Weight

Opens the Edit Catch Weights form, which is used to enter the actual Catch Weight recorded when material was produced for Parts flagged as "Catch Weight" in their Item Master Properties tab.

  • The "Default" value is supplied from the "Unit Weight" defined on the Part's Item Master Calcs tab.
  • If a base Unit of Measure is not indicated for the "Weight" type, the system will default the unit's Catch Weight to "1", regardless of the "Unit Weight" value specified.

View Payroll

Generates a Payroll Reporting "Job Payroll Shifts" report for the selected Job, which displays the hours, date, and time for the Labor Group to which the current Worker is assigned.

  • Users can add new Workers and appropriate payroll entries using this report.
  • Users with the "Production -- allow negative time sheet hours" security setting set to yes can enter negative time sheet hours to offset mistakes.
  • Note: Deacom version 16.06.058 adds a specific security setting to control which users can add Operations in the system. If this security is set to "No", users will not be able to add an Operation when clicking the (+) Add New button in the Operation search field when usign the View Payroll button. Previously, users would need to be restricted from accessing the Production Maintenance area to control this option.

Split Lot

Displays the "Split Lot" form allowing user to split the currently selected line into multiple lots. When the user is done splitting the lot, the number of lots specified on the Split Lot form will show as multiple lines for multiple system lots on the "Close/Relieve Job" form. Note that the same lot may be split multiple times if necessary.

  • When splitting lots and printing lot labels, one lot label will be printed for each unique system lot.

Zero All

If clicked, zeros out all quantities listed in the "Finish Qty" column.

Job

Displays the Job number.

Shift

Option to select the shift, for the selected Work Crew, responsible for Finishing or Closing the job.

  • Shifts allow the grouping of Crews and supports the ability to generate a Shift Efficiency report.
  • Shifts are linked to Crews via the "Shift" field on the Work Crew record. Additional information is available via Managing Workers.

Work Crew

Displays the Crew responsible for production of the goods in the job, as indicated on the Job header.

Date

The date the Job will be marked as closed. Defaults to the current date but may be changed.

Relieve Labor Costs - Job Finish

If checked, relieves costs for all labor that has been entered against this Job.

  • The default setting for this flag is controlled via the "Relieve Labor Costs / Job Finish" flag in Production Options.

Relieve All Issued Materials

If checked, relieves issued material from WIP regardless of the Inventory Costing method selected in Accounting Options.

  • When re-opening a job, the user may un-relieve an inventory expensed for the job. This requires security setting "Production -- un-relieve expensed materials when re-opening jobs".
  • If this flag is not checked and the user clicks "Save", the system will prompt the user to verify they wish to continue.
  • The default setting for this flag is controlled via the "Relieve All Issued / Job Finish" flag in Production Options.
  • The "Job Relieve Test Type" selection in Production Options also effects how issued materials are handled.
  • The "Expensed Material" report is useful for determining situations in which, at the end of the Job, inventory is relieved but does not into a specific Lot, which typically occurs when this flag is checked when closing a job where nothing was produced/finished on the Job.

Close Job

If checked, the system also checks the "Relieve Labor Costs - Job Finish" and "Relieve All Issued Materials" flags.

  • Security exists to control access to this flag.
  • The WIP GL accounts affected by the Job close are defined in Accounting Options.
  • Work Flow sequences can be flagged as "Required to Close Job". If checked, that sequence must be completed before the Job can be closed.
    • This flag does not prevent material form being produced or relieved.

Print Job Labels After Finish

If checked, the Job Label for Lot(s) being finished will be printed when "Save" is clicked.

Print Master Lot Labels After Finish

If checked, the Print Quantity form will be displayed and the Master Lot label for the Lot(s) being finished will be printed after the "Finish" button is clicked.

Close/Relieve Job form

Opened via the "Modify" button on the Close/Relieve Job form, this form is used to modify the finish quantity, leftover quantity, specify different Location Types and Locations, and add item attributes. When finishing production, the following records/preferences are checked when populating the default location and location type on the close/relieve job form.

  • Facility override on the Item Master.
  • Item Master General 1 tab's "Default Location Type", if it belongs to the Facility on the Job.
  • If that Location Type does not belong to the Job's Facility, pull in that Facility's default Location Type and Location, if any.
  • Otherwise blank.
  • This form is disabled when using a Job Type of "Planning".

Field

Description

Part Number

Displays the Part Number from the Job line.

Description

Displays the Part's description.

Original Qty

Displays the original Job line quantity.

Remaining

Displays the remaining quantity left to be finished for the selected Job line.

Finish Qty

Displays the amount to be finished. 

  • The default for this field can be set via the "Default Finish Quantity" field on the Part's Item Master General 2 tab or the General tab on facility part cross references. Reference the General 2 tab link for additional information.
  • Once a quantity is finished by entering an amount and saving the Job, it may only be modified by users with access to "Production - edit previously finished job line".
  • Set to "0" when using a Job Type of "Planning".

Leftover

Displays the difference between the Remaining and Finish quantities.

Tally

Displays the tally amount for this finish, if the item is defined with an "Order Type" of "Tally" on its Item Master General 1 tab.

Container Number

Search field used to select a Container that was issued to the job. Containers are issued to jobs by issuing lots stored in Containers. Used in situations where materials are meant to be finished into Containers.

  • Issuing upon finishing is driven by the "Input Production When Issuing" flag on the Job Category. If this flag is checked on the job category specified on the job, then finishing must occur in order for materials to be issued.

Container Unit

Search field used to select a Unit of Measure to indicate the total number of units that can be placed in a full container of this item.

Location Type

Displays the Location Type where the finished item will be placed once the finish process is complete.

  • The default is based on the hierarchy below, unless the item being finished has the "Finish Job to WIP Materials Location" flag checked.
    • Default Finishing Location Type specified on the Edit Item Facility form, accessible via the Item Master > Facilities tab of the Part being finished.
    • Default Location Type specified on the Edit Item Facility form, accessible via the Item Master > Facilities tab of the Part being finished.
    • Default Finishing Location Type specified on the Part's Item Master > General 1 tab, assuming the Location Type is linked to the Facility selected on the Job being finished.
    • Default Location Type specified on the Part's Item Master > General 1 tab, assuming the Location Type is linked to the Facility selected on the Job being finished.
    • If the Location Type is not linked to the Job's Facility, the Job Facility's default Location Type, if specified.
  • If the "Finish Job to WIP Materials Location" flag is checked, the inventory for this item will default to the same Location Type where the Raw Materials used in the production of this item have been issued, provided all Raw Materials have been issued to the same Location Type.
  • If all Raw Materials for production of this item have not been issued to the same Location Type, the default Location Type is used.

Location

Displays the Location where the finished item will be placed once the finish process is complete.

  • The default is provided based on the hierarchy below, unless the item being finished has the "Finish Job to WIP Materials Location" flag checked.
    • Default Finishing Location specified on the Edit Item Facility form, accessible via the Item Master > Facilities tab of the Part being finished.
    • Default Location specified on the Edit Item Facility form, accessible via the Item Master > Facilities tab of the Part being finished.
    • Default Finishing Location specified on the Part's Item Master > General 1 tab.
    • Default Location specified on the Part's Item Master > General 1 tab.
    • The Job Facility's default Location, if specified.
  • If the "Finish Job to WIP Materials Location" flag is checked, the inventory for this item will default to the same Location Type where the Raw Materials used in the production of this item have been issued, provided all Raw Materials have been issued to the same Location Type.
  • If all Raw Materials for production of this item have not been issued to the same Location Type, the default Location Type is used.

Master Lot

Searchbox used to a select an existing Master Lot to which the inventory will be finished to. This box is disabled if the "Make Master Lot" box is checked.

Lot

Defines the Lot number that will be assigned once the finish process is complete.

  • The default value is the Deacom Job number, unless an expression has been entered in the "Lot # Expression" field via Inventory Options.

Expires

Option to define the expiration date for the selected part number. The expiration date will be calculated if there is no user-entered date specified here when the lot is finished.

The hierarchy that will be applied is:

IF the Expires field is not empty

                       Expiration Date = Expires field

ELSE IF the Lot Expires Calc. field in Inventory > Options is not empty

                       Expiration Date = The calculated expression value of the lot expires calc.

ELSE IF one of the relieved lots parts have the BOM setting of 'Propagate Expiration Date' = TRUE

                       Expiration Date = the oldest relieved lot’s fi_expires date for that part.

ELSE IF the produced part’s shelf life days > 0

                       Expiration Date = the calculated expiration date based on the items' shelf life days. 

Attribute 1-3

Text field, up to 30 characters, used to indicate user- or company-specific Lot and inventory information.

  • Captions for these fields are configured via System > Maintenance > Captions.

Density

Displays the actual density of the product when finishing material.

  • Only available if the "Measured Density" flag is checked on the Item Master Properties tab.

Make Master Lot

When checked, the Master Lot searchbox is disabled and when the "Save" button is clicked, the "Edit Master Lot" form is displayed. The value in the "Master Lot" field on this form is determined by the "Master Lot # Generation" and "Master Lot Expression" fields located in Inventory Options.

  • Once the Master Lot number has been entered or verified, users can then specify the appropriate weight and click "Save" to have the lot quantity that is being finished made into a Master Lot. Note that if this box is not checked, the Master Lot searchbox is enabled and and users can select a Master Lot for the inventory to be finished to. If the system option "Input Master Lot Weight" is checked users will be required to enter a weight for the master lot.
  • If an item has the "Make Master Lot At Job Finish" property flag checked, this field will be checked and disabled

Job view mode

Opened via the "View Detail" button on a Production report. The majority of the buttons and fields available are defined in the Job Entry Encyclopedia page. Those not defined in that page are detailed below. The majority of these fields are based on activities that would occur after a job is saved and processed, i.e. material issued, job finished.

Button

Description

BOM

Displays the "Explosion - Single Level" Bill of Materials report for the selected job item.

View Req'd

If clicked, displays a list of materials that are required by the BOM to complete the job, as well as other information such as job number, total issued, total relieved, and staged quantity.

View Issued

Lists the lots that have been issued to the job

View Staged

If clicked, generate an Inventory Reporting Lot Summary report displaying staged lots and quantities for this Job.

  • Note that inventory lots summed as a result of the "Summarize Lots When Viewing Issued Materials" system option will not apply to the "View Staged" button.
  • The Inventory Lot Summary report grid (invlot) contains a new variable/column called "Iteration" to display the staging iteration (st_stagcnt) for the stagged lot.

User Fields

Displays the job header user fields.

Payroll Detail

Launches the Payroll Detail reports listing the Jobs, Work Centers, Operations, and In and Out hours for the selected Worker. 

Inventory

Displays the inventory issued, staged, and consumed by the Job.

Job Labels

Allows users to print the one label per finished lot for the selected row when the "Label Print Qty" field in Inventory > Options is set to print "By Lot".

Linked SOs

Displays any sales orders linked to the job.

Note: In view mode, users have access to the Job's Work Flow tab, which allows users to view the current Work Flow and modify its sequences.